Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more
نویسندگان
چکیده
Designations used by companies to distinguish their products are often claimed as trademarks or registered trademarks. In all instances in which Morgan Kaufmann Publishers is aware of a claim, the product names appear in initial capital or all capital letters. Readers, however, should contact the appropriate companies for more complete information regarding trademarks and registration. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means—electronic, mechanical, photocopying, scanning, or otherwise—without prior written permission of the publisher. may also complete your request on-line via the Elsevier homepage (http://elsevier.com), by selecting " Support & Contact " then " Copyright and Permission " and then " Obtaining Permissions. " Page 197: " Make a new plan Stan. .. and get yourself free. Physical database design : the database professional's guide to exploiting indexes, views, storage, and more / Sam Lightstone, Toby Teorey, and Tom Nadeau. p. cm.-(The Morgan Kaufmann series in database management systems) Includes bibliographical references and index.
منابع مشابه
Bitmap Join Indexes vs. Data Partitioning
IntroductIon Scientific databases and data warehouses store large amounts of data ith several tables and attributes. For instance, the Sloan Digital Sky Survey (SDSS) astronomical database contains a large number of tables with hundreds of attributes, which can be queried in various combinations (Papadomanolakis & Ailamaki, 2004). These queries involve many tables using binary operations, such ...
متن کاملAutonomous Selection of Indexes and Materialized Views in Two Commerical Database Management Systems
The selection of the most beneficial indexes and materialized views (MVs) is a well-known issue in physical database design. The chosen set of indexes and MVs is crucial to the overall performance of the DBMS as it relates to specific workloads. Since this is such an important aspect of physical database design, database administrators (DBAs) spend a great amount of time selecting the best inde...
متن کاملCORADD: Correlation Aware Database Designer for Materialized Views and Indexes
We describe an automatic database design tool that exploits correlations between attributes when recommending materialized views (MVs) and indexes. Although there is a substantial body of related work exploring how to select an appropriate set of MVs and indexes for a given workload, none of this work has explored the effect of correlated attributes (e.g., attributes encoding related geographic...
متن کاملCORADD: Correlation Aware Database Designer for Materialized Views and Indexes Citation
We describe an automatic database design tool that exploits correlations between attributes when recommending materialized views (MVs) and indexes. Although there is a substantial body of related work exploring how to select an appropriate set of MVs and indexes for a given workload, none of this work has explored the effect of correlated attributes (e.g., attributes encoding related geographic...
متن کاملSeparating indexes from data: a distributed scheme for secure database outsourcing
Database outsourcing is an idea to eliminate the burden of database management from organizations. Since data is a critical asset of organizations, preserving its privacy from outside adversary and untrusted server should be warranted. In this paper, we present a distributed scheme based on storing shares of data on different servers and separating indexes from data on a distinct server. Shamir...
متن کامل